Example: Replace Empty Values

The empty values of the dataset will be replaced with either the previous or next value in the specific field.

Initial dataset:

Configuration:

Selected Fields: Field1, Field2, Field3 and Field4

Fill type: Set to previous

Resulting dataset:

Note that there are no values in Field2 for rows 1 to 5. The reason for this is that the fill type was "Set to previous", and there are no rows prior to row 1.

Further optional configuration:

Selected Fields: Field2

Fill type: Set to next

Resulting dataset:

---

Related topics:

• Overview of operation: Replace empty values

• Configuring operation: Replace empty values

• Overview of operations

• Technical comparison of operations

• Overview of icons